Work in progress: performance regression tracking

Note:

Solution

data.table

groupby

Overview
by Question (k=1e2, no NA, unsorted)
Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 3.5 3.5 -3% 3.3 -5%
2 4.3 3.5 23% 3.5 16%
3 5.4 4.8 11% 4.5 14%
4 6.1 6.1 2% 5.6 10%
5 5.9 5.5 9% 4.9 11%
6 47.2 47.9 -2%
7 128.6 106.7 17%
8 167.6 146.9 11%
9 16.0 14.7 9% 43.9 -46%
10 67.2 68.1 1% 93.7 -12%
by Size (k=1e2, no NA, unsorted)
Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e7 1.1 1.1 6%
1e8 11.1 9.9 9%
1e9 123.3 111.3 8%
by K cardinality (no NA, unsorted)
K Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 45.2 40.8 8%
1e1
2e0 158.3 141.9 3%
by NA fraction (k=1e2, unsorted)
NA fraction Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 45.2 40.8 8%
by Sortedness (k=1e2, no NA)
Sorted Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 45.2 40.8 8%
1 43.1 36.2 18%
Question
by Question Size (k=1e2, no NA, unsorted)
Q Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e7 0.1 0.2 -33% 0.2 -32%
1 1e8 1.1 0.9 23% 1.0 12%
1 1e9 9.1 9.3 -2% 8.7 4%
2 1e7 0.1 0.1 7% 0.1 0%
2 1e8 1.3 1.0 40% 1.0 28%
2 1e9 11.5 9.3 23% 9.5 20%
3 1e7 0.2 0.1 26% 0.1 28%
3 1e8 1.4 1.5 -6% 1.5 -8%
3 1e9 14.5 12.8 13% 11.8 22%
4 1e7 0.2 0.2 7% 0.2 21%
4 1e8 1.6 1.5 0% 1.6 -1%
4 1e9 16.4 16.4 0% 14.9 10%
5 1e7 0.2 0.2 23% 0.2 11%
5 1e8 1.4 1.5 -2% 1.5 -1%
5 1e9 16.0 14.9 7% 13.0 22%
6 1e7 1.1 1.2 -5%
6 1e8 11.4 11.6 -1%
6 1e9 129.0 131.0 -1%
7 1e7 3.3 3.0 9%
7 1e8 35.6 28.8 23%
7 1e9 346.8 288.2 20%
8 1e7 3.4 3.1 9%
8 1e8 36.1 32.5 11%
8 1e9 463.2 405.2 14%
9 1e7 1.1 1.0 12% 1.4 -20%
9 1e8 4.3 4.0 6% 9.4 -54%
9 1e9 42.6 39.0 9% 121.0 -64%
10 1e7 1.5 1.5 3% 1.6 -5%
10 1e8 16.6 16.2 2% 16.6 0%
10 1e9 183.4 186.7 -1% 262.8 -30%
by Question K cardinality (no NA, unsorted)
Q K Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e2 3.5 3.5 -3% 3.3 -5%
1 1e1 5.5 5.1 12% 5.0 15%
1 2e0 5.4 5.5 -5% 6.5 -5%
2 1e2 4.3 3.5 23% 3.5 16%
2 1e1 5.5 4.8 30% 4.2 40%
2 2e0 6.6 5.7 0% 5.9 7%
3 1e2 5.4 4.8 11% 4.5 14%
3 1e1 10.9 9.5 6% 9.3 9%
3 2e0 213.7 213.2 2%
4 1e2 6.1 6.1 2% 5.6 10%
4 1e1 8.6 8.4 -3% 8.5 0%
4 2e0 8.1 7.8 -1%
5 1e2 5.9 5.5 9% 4.9 11%
5 1e1 14.0 10.2 19% 10.1 21%
5 2e0 4.2 3.6 9% 3.7 23%
6 1e2 47.2 47.9 -2%
6 1e1 40.5 39.4 0%
6 2e0 3.0 3.0 7%
7 1e2 128.6 106.7 17%
7 1e1 994.1
7 2e0 703.2 606.6 14%
8 1e2 167.6 146.9 11%
8 1e1 195.1 165.0 17%
8 2e0 826.2 728.6 11%
9 1e2 16.0 14.7 9% 43.9 -46%
9 1e1 27.8
9 2e0 1.6 1.5 8% 2.5 -35%
10 1e2 67.2 68.1 1% 93.7 -12%
10 1e1 15.0 14.0 0% 11.1 20%
10 2e0 10.9 10.8 1% 37.3 -72%
K cardinality
by K cardinality Size (no NA, unsorted)
K Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 1e7 1.1 1.1 6%
1e2 1e8 11.1 9.9 9%
1e2 1e9 123.3 111.3 8%
1e1 1e7 6.6 5.9 6%
1e1 1e8 71.6 61.7 11%
1e1 1e9
2e0 1e7 28.7 25.8 3%
2e0 1e8 284.8 248.9 3%
2e0 1e9 166.1 164.5 5%
by K cardinality Question (no NA, unsorted)
K Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 1 3.5 3.5 -3% 3.3 -5%
1e2 2 4.3 3.5 23% 3.5 16%
1e2 3 5.4 4.8 11% 4.5 14%
1e2 4 6.1 6.1 2% 5.6 10%
1e2 5 5.9 5.5 9% 4.9 11%
1e2 6 47.2 47.9 -2%
1e2 7 128.6 106.7 17%
1e2 8 167.6 146.9 11%
1e2 9 16.0 14.7 9% 43.9 -46%
1e2 10 67.2 68.1 1% 93.7 -12%
1e1 1 5.5 5.1 12% 5.0 15%
1e1 2 5.5 4.8 30% 4.2 40%
1e1 3 10.9 9.5 6% 9.3 9%
1e1 4 8.6 8.4 -3% 8.5 0%
1e1 5 14.0 10.2 19% 10.1 21%
1e1 6 40.5 39.4 0%
1e1 7 994.1
1e1 8 195.1 165.0 17%
1e1 9 27.8
1e1 10 15.0 14.0 0% 11.1 20%
2e0 1 5.4 5.5 -5% 6.5 -5%
2e0 2 6.6 5.7 0% 5.9 7%
2e0 3 213.7 213.2 2%
2e0 4 8.1 7.8 -1%
2e0 5 4.2 3.6 9% 3.7 23%
2e0 6 3.0 3.0 7%
2e0 7 703.2 606.6 14%
2e0 8 826.2 728.6 11%
2e0 9 1.6 1.5 8% 2.5 -35%
2e0 10 10.9 10.8 1% 37.3 -72%
NA fraction
by NA fraction Size (k=1e2, unsorted)
NA fraction Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 1.1 1.1 6%
0 1e8 11.1 9.9 9%
0 1e9 123.3 111.3 8%
Sortedness
by Sortedness Size (k=1e2, no NA)
Sorted Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 1.1 1.1 6%
0 1e8 11.1 9.9 9%
0 1e9 123.3 111.3 8%
1 1e7 1.1 1.0 17%
1 1e8 10.8 8.9 12%
1 1e9 117.3 98.7 26%

join

Overview
by Question (no NA, unsorted)
Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 3.2 3.2 5%
2 2.8 2.6 3%
3 5.3 5.2 6%
4 2.9 2.6 21%
5 14.6 14.2 4%
by Size (no NA, unsorted)
Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e7 1.1 1.0 12%
1e8 10.5 10.1 4%
by NA fraction (unsorted)
NA fraction Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 5.8 5.6 8%
by Sortedness (no NA)
Sorted Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 5.8 5.6 8%
Question
by Question Size (no NA, unsorted)
Q Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e7 0.6 0.5 10%
1 1e8 5.9 5.9 0%
2 1e7 0.5 0.5 0%
2 1e8 5.2 4.8 6%
3 1e7 1.0 0.9 11%
3 1e8 9.6 9.4 1%
4 1e7 0.6 0.4 34%
4 1e8 5.2 4.8 8%
5 1e7 2.7 2.6 5%
5 1e8 26.5 25.8 2%
NA fraction
by NA fraction Size (unsorted)
NA fraction Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 1.1 1.0 12%
0 1e8 10.5 10.1 4%
Sortedness
by Sortedness Size (no NA)
Sorted Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 1.1 1.0 12%
0 1e8 10.5 10.1 4%

dplyr

groupby

Overview
by Question (k=1e2, no NA, unsorted)
Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 14.0 13.8 1% 15.1 -2% 13.9 2% 8.2 74%
2 37.4 38.0 -1% 36.3 1% 37.4 0% 28.6 48%
3 177.8 179.8 -2% 180.0 -2% 178.1 -1% 83.8 105%
4 33.1 32.8 2% 34.0 0% 33.0 3% 30.8 7%
5 192.5 186.4 0% 190.6 -1% 186.6 2% 189.7 0%
6 68.9 73.5 -2% 70.3 -1% 69.4 0%
7 220.5 271.7 -8% 276.5 -9% 216.6 0%
8 496.0 570.5 -5% 575.4 -6% 490.3 0%
9 56.5 57.3 -1% 67.3 -6% 55.7 1%
10 63.7 61.5 3% 63.7 0% 61.7 3%
by Size (k=1e2, no NA, unsorted)
Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e7 8.0 7.8 0% 8.1 -1% 7.8 2%
1e8 29.8 30.4 -1% 30.1 -1% 29.9 0%
1e9 400.6 442.3 -4% 449.9 -6% 395.3 0%
by K cardinality (no NA, unsorted)
K Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 141.2 154.7 -1% 157.2 -3% 139.5 1%
1e1 139.9 136.8 0% 132.3 0% 136.2 1%
2e0 64.9 64.9 1% 66.4 0% 66.3 0%
by NA fraction (k=1e2, unsorted)
NA fraction Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 141.2 154.7 -1% 157.2 -3% 139.5 1%
by Sortedness (k=1e2, no NA)
Sorted Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 141.2 154.7 -1% 157.2 -3% 139.5 1%
1 137.2 136.1 0% 136.4 0%
Question
by Question Size (k=1e2, no NA, unsorted)
Q Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e7 0.4 0.4 0% 0.4 3% 0.4 4% 0.2 88%
1 1e8 3.6 3.6 1% 3.7 -2% 3.6 0% 2.2 63%
1 1e9 38.1 37.5 1% 41.3 -7% 37.6 1% 22.2 71%
2 1e7 0.8 0.8 0% 0.8 2% 0.8 3% 0.5 76%
2 1e8 9.3 9.5 -1% 9.5 -2% 9.5 -1% 6.6 40%
2 1e9 102.0 103.6 -1% 98.7 3% 102.0 0% 78.6 29%
3 1e7 1.3 1.5 -7% 1.4 -5% 1.4 -2% 0.7 84%
3 1e8 37.0 36.8 0% 37.0 0% 37.4 -1% 16.8 119%
3 1e9 495.1 501.0 -1% 501.4 -1% 495.4 0% 233.8 111%
4 1e7 0.6 0.6 0% 0.6 0% 0.6 7% 0.6 10%
4 1e8 8.7 8.2 6% 8.5 1% 8.5 2% 8.3 4%
4 1e9 89.9 89.6 0% 92.9 -3% 90.0 0% 83.4 7%
5 1e7 1.5 1.5 -2% 1.6 -7% 1.5 2% 1.5 1%
5 1e8 37.9 38.2 0% 37.6 0% 37.9 0% 39.1 -2%
5 1e9 538.0 519.6 3% 532.6 1% 520.5 3% 528.6 1%
6 1e7 1.7 1.7 2% 1.7 0% 1.7 2%
6 1e8 15.9 16.7 -4% 16.3 -2% 16.0 0%
6 1e9 189.2 202.0 -6% 192.9 -1% 190.6 0%
7 1e7 1.7 1.7 -2% 1.8 -5% 1.7 1%
7 1e8 39.1 39.7 -1% 39.9 -1% 39.7 -1%
7 1e9 620.8 773.7 -19% 787.8 -21% 608.4 2%
8 1e7 6.7 6.7 0% 7.0 -4% 6.7 0%
8 1e8 104.5 108.3 -3% 106.0 -1% 104.6 0%
8 1e9 1376.7 1596.6 -13% 1613.3 -14% 1359.7 1%
9 1e7 1.5 1.4 3% 1.5 0% 1.4 4%
9 1e8 12.2 13.1 -6% 12.5 -1% 12.2 0%
9 1e9 155.9 157.5 0% 188.0 -17% 153.5 1%
10 1e7 63.7 61.5 3% 63.7 0% 61.7 3%
by Question K cardinality (no NA, unsorted)
Q K Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e2 14.0 13.8 1% 15.1 -2% 13.9 2% 8.2 74%
1 1e1 12.1 12.8 0% 12.8 0% 12.4 3% 5.0 147%
1 2e0 10.9 10.7 3% 10.9 0% 10.8 1% 5.1 146%
2 1e2 37.4 38.0 -1% 36.3 1% 37.4 0% 28.6 48%
2 1e1 24.0 23.2 1% 24.0 0% 24.1 3% 12.9 114%
2 2e0 20.1 20.0 2% 20.6 -3% 20.0 2% 8.0 164%
3 1e2 177.8 179.8 -2% 180.0 -2% 178.1 -1% 83.8 105%
3 1e1 401.8 397.4 0% 395.2 0% 410.8 -1% 171.9 132%
3 2e0 110.1 109.5 3% 110.9 2% 110.6 3% 53.8 149%
4 1e2 33.1 32.8 2% 34.0 0% 33.0 3% 30.8 7%
4 1e1 18.9 18.6 2% 18.7 -1% 19.5 2% 16.2 14%
4 2e0 1.6 1.6 0% 1.6 0% 1.6 1% 1.6 5%
5 1e2 192.5 186.4 0% 190.6 -1% 186.6 2% 189.7 0%
5 1e1 532.5 508.0 1% 475.7 3% 490.3 4% 463.9 -4%
5 2e0 83.8 81.9 0% 86.6 -1% 85.2 1% 110.8 -17%
6 1e2 68.9 73.5 -2% 70.3 -1% 69.4 0%
6 1e1 45.1 45.3 0% 44.8 0% 46.2 0%
6 2e0 4.0 4.0 0% 4.0 -1% 4.0 1%
7 1e2 220.5 271.7 -8% 276.5 -9% 216.6 0%
7 1e1 57.8 58.5 -1% 57.5 0% 57.9 0%
7 2e0 159.3 160.1 0% 165.4 -2% 164.3 -1%
8 1e2 496.0 570.5 -5% 575.4 -6% 490.3 0%
8 1e1 102.4 105.1 -2% 102.2 0% 102.2 0%
8 2e0 236.9 239.3 0% 241.7 -1% 244.1 -2%
9 1e2 56.5 57.3 -1% 67.3 -6% 55.7 1%
9 1e1 4.1 4.1 0% 3.9 1% 3.9 2%
9 2e0 3.2 3.2 0% 3.2 0% 3.3 -2%
10 1e2 63.7 61.5 3% 63.7 0% 61.7 3%
10 1e1 67.0 67.6 0% 66.3 1% 67.2 0%
10 2e0 72.6 72.2 0% 72.4 0% 72.9 0%
K cardinality
by K cardinality Size (no NA, unsorted)
K Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 1e7 8.0 7.8 0% 8.1 -1% 7.8 2%
1e2 1e8 29.8 30.4 -1% 30.1 -1% 29.9 0%
1e2 1e9 400.6 442.3 -4% 449.9 -6% 395.3 0%
1e1 1e7 10.7 10.8 0% 10.6 0% 10.7 3%
1e1 1e8 53.8 55.0 0% 53.8 1% 53.8 1%
1e1 1e9 484.6 469.4 0% 452.8 1% 469.0 0%
2e0 1e7 17.6 17.4 1% 17.5 0% 17.4 2%
2e0 1e8 122.7 122.9 0% 126.0 0% 126.0 -1%
2e0 1e9 41.8 41.6 0% 42.6 -1% 41.6 0% 17.9 128%
by K cardinality Question (no NA, unsorted)
K Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 1 14.0 13.8 1% 15.1 -2% 13.9 2% 8.2 74%
1e2 2 37.4 38.0 -1% 36.3 1% 37.4 0% 28.6 48%
1e2 3 177.8 179.8 -2% 180.0 -2% 178.1 -1% 83.8 105%
1e2 4 33.1 32.8 2% 34.0 0% 33.0 3% 30.8 7%
1e2 5 192.5 186.4 0% 190.6 -1% 186.6 2% 189.7 0%
1e2 6 68.9 73.5 -2% 70.3 -1% 69.4 0%
1e2 7 220.5 271.7 -8% 276.5 -9% 216.6 0%
1e2 8 496.0 570.5 -5% 575.4 -6% 490.3 0%
1e2 9 56.5 57.3 -1% 67.3 -6% 55.7 1%
1e2 10 63.7 61.5 3% 63.7 0% 61.7 3%
1e1 1 12.1 12.8 0% 12.8 0% 12.4 3% 5.0 147%
1e1 2 24.0 23.2 1% 24.0 0% 24.1 3% 12.9 114%
1e1 3 401.8 397.4 0% 395.2 0% 410.8 -1% 171.9 132%
1e1 4 18.9 18.6 2% 18.7 -1% 19.5 2% 16.2 14%
1e1 5 532.5 508.0 1% 475.7 3% 490.3 4% 463.9 -4%
1e1 6 45.1 45.3 0% 44.8 0% 46.2 0%
1e1 7 57.8 58.5 -1% 57.5 0% 57.9 0%
1e1 8 102.4 105.1 -2% 102.2 0% 102.2 0%
1e1 9 4.1 4.1 0% 3.9 1% 3.9 2%
1e1 10 67.0 67.6 0% 66.3 1% 67.2 0%
2e0 1 10.9 10.7 3% 10.9 0% 10.8 1% 5.1 146%
2e0 2 20.1 20.0 2% 20.6 -3% 20.0 2% 8.0 164%
2e0 3 110.1 109.5 3% 110.9 2% 110.6 3% 53.8 149%
2e0 4 1.6 1.6 0% 1.6 0% 1.6 1% 1.6 5%
2e0 5 83.8 81.9 0% 86.6 -1% 85.2 1% 110.8 -17%
2e0 6 4.0 4.0 0% 4.0 -1% 4.0 1%
2e0 7 159.3 160.1 0% 165.4 -2% 164.3 -1%
2e0 8 236.9 239.3 0% 241.7 -1% 244.1 -2%
2e0 9 3.2 3.2 0% 3.2 0% 3.3 -2%
2e0 10 72.6 72.2 0% 72.4 0% 72.9 0%
NA fraction
by NA fraction Size (k=1e2, unsorted)
NA fraction Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 8.0 7.8 0% 8.1 -1% 7.8 2%
0 1e8 29.8 30.4 -1% 30.1 -1% 29.9 0%
0 1e9 400.6 442.3 -4% 449.9 -6% 395.3 0%
Sortedness
by Sortedness Size (k=1e2, no NA)
Sorted Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 8.0 7.8 0% 8.1 -1% 7.8 2%
0 1e8 29.8 30.4 -1% 30.1 -1% 29.9 0%
0 1e9 400.6 442.3 -4% 449.9 -6% 395.3 0%
1 1e7 6.8 6.8 -3% 6.8 -4% 6.8 -2%
1 1e8 27.8 27.0 3% 27.6 1% 27.1 1%
1 1e9 391.5 389.0 0% 389.7 1%

join

Overview
by Question (no NA, unsorted)
Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 11.1 11.4 -2% 11.2 0%
2 8.2 8.3 3% 8.3 -2%
3 8.5 8.5 -2% 8.7 -1%
4 12.8 12.8 -2% 12.9 -2%
5 64.1 63.9 0% 65.2 -3%
by Size (no NA, unsorted)
Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e7 4.2 4.3 0% 4.3 -3%
1e8 37.7 37.7 0% 38.2 -1%
by NA fraction (unsorted)
NA fraction Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 20.9 21.0 0% 21.3 -2%
by Sortedness (no NA)
Sorted Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 20.9 21.0 0% 21.3 -2%
Question
by Question Size (no NA, unsorted)
Q Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e7 6.0 6.1 -1% 6.0 0%
1 1e8 16.2 16.7 -3% 16.3 0%
2 1e7 1.4 1.3 9% 1.5 -4%
2 1e8 14.9 15.3 -2% 15.1 -1%
3 1e7 1.4 1.4 -5% 1.4 -1%
3 1e8 15.7 15.7 0% 16.0 -1%
4 1e7 2.0 2.1 -5% 2.1 -4%
4 1e8 23.6 23.5 0% 23.8 0%
5 1e7 10.1 10.3 -1% 10.7 -5%
5 1e8 118.0 117.4 0% 119.7 -1%
NA fraction
by NA fraction Size (unsorted)
NA fraction Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 4.2 4.3 0% 4.3 -3%
0 1e8 37.7 37.7 0% 38.2 -1%
Sortedness
by Sortedness Size (no NA)
Sorted Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 4.2 4.3 0% 4.3 -3%
0 1e8 37.7 37.7 0% 38.2 -1%

pandas

groupby

Overview
by Question (k=1e2, no NA, unsorted)
Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1.1 1.2 -1% 1.1 -6% 1.1 0% 1.0 18%
2 4.2 4.1 6% 4.0 0% 3.8 5% 3.3 26%
3 4.4 4.7 -7% 4.4 2% 3.8 0% 4.2 7%
4 3.0 3.1 -6% 2.9 0% 2.9 0% 2.5 15%
5 7.9 7.9 -1% 7.9 1% 7.3 -4% 8.4 -6%
6 8.8 8.7 -3% 8.6 0% 8.6 0%
7 3.7 3.6 1% 3.5 -3% 3.4 -7%
8 28.3 26.1 2% 26.9 3% 25.9 4%
9 29.3 28.6 0% 28.6 2% 29.5 -2% 27.1 11%
10 113.3
by Size (k=1e2, no NA, unsorted)
Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e7
1e8
by K cardinality (no NA, unsorted)
K Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2
1e1
2e0
by NA fraction (k=1e2, unsorted)
NA fraction Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0
by Sortedness (k=1e2, no NA)
Sorted Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0
1
Question
by Question Size (k=1e2, no NA, unsorted)
Q Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e7 0.3 0.3 0% 0.3 -20% 0.3 2% 0.2 20%
1 1e8 2.0 2.1 -3% 1.9 7% 2.0 0% 1.7 16%
2 1e7 0.7 0.7 11% 0.8 -6% 0.8 -4% 0.6 24%
2 1e8 7.7 7.6 0% 7.3 5% 6.7 14% 6.0 28%
3 1e7 0.5 0.5 -8% 0.5 4% 0.6 -20% 0.5 10%
3 1e8 8.3 8.8 -5% 8.3 0% 7.0 18% 8.0 4%
4 1e7 0.5 0.6 -8% 0.5 -4% 0.5 0% 0.5 12%
4 1e8 5.4 5.6 -3% 5.3 3% 5.4 1% 4.6 17%
5 1e7 0.9 1.0 -3% 0.9 4% 1.2 -19% 1.0 -5%
5 1e8 14.9 14.8 0% 15.0 -1% 13.5 10% 15.9 -6%
6 1e7 1.5 1.7 -9% 1.6 -1% 1.6 -5%
6 1e8 16.2 15.7 2% 15.6 3% 15.6 3%
7 1e7 0.5 0.5 1% 0.6 -12% 0.7 -25%
7 1e8 6.8 6.7 1% 6.5 4% 6.1 10%
8 1e7 3.6 3.7 -4% 3.5 2% 3.6 0%
8 1e8 53.0 48.5 9% 50.4 5% 48.3 9%
9 1e7 12.8 13.3 -3% 12.6 1% 13.4 -4% 11.0 16%
9 1e8 45.8 43.8 4% 44.6 2% 45.5 0% 43.2 6%
10 1e7 9.7
10 1e8 216.9
by Question K cardinality (no NA, unsorted)
Q K Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e2 1.1 1.2 -1% 1.1 -6% 1.1 0% 1.0 18%
1 1e1 1.1 1.1 2% 1.0 4% 1.1 0% 1.0 12%
1 2e0 1.1 1.1 3% 1.1 4% 1.2 -1% 1.0 17%
2 1e2 4.2 4.1 6% 4.0 0% 3.8 5% 3.3 26%
2 1e1 3.2 3.3 -5% 3.5 -3% 2.9 4% 2.6 13%
2 2e0 3.0 3.0 -3% 3.2 -3% 2.8 2% 2.6 15%
3 1e2 4.4 4.7 -7% 4.4 2% 3.8 0% 4.2 7%
3 1e1 8.4 8.6 2% 8.6 0% 8.1 4% 10.8 -24%
3 2e0 14.6 14.7 0% 15.8 -3% 13.4 7% 30.1 -48%
4 1e2 3.0 3.1 -6% 2.9 0% 2.9 0% 2.5 15%
4 1e1 2.9 2.9 1% 2.9 1% 2.9 3% 2.5 16%
4 2e0 2.9 3.0 -3% 2.9 0% 2.9 0% 2.5 13%
5 1e2 7.9 7.9 -1% 7.9 1% 7.3 -4% 8.4 -6%
5 1e1 15.9 16.7 -1% 17.3 -5% 15.8 1% 15.9 -2%
5 2e0 32.6 31.9 2% 33.8 0% 31.7 3% 30.2 7%
6 1e2 8.8 8.7 -3% 8.6 0% 8.6 0%
6 1e1 6.2 6.3 0% 6.3 -1% 6.1 2%
6 2e0 5.6 5.6 2% 5.9 0% 5.5 4%
7 1e2 3.7 3.6 1% 3.5 -3% 3.4 -7%
7 1e1 8.2 8.4 -1% 8.3 -2% 7.8 8%
7 2e0 17.8 17.7 1% 17.9 0% 16.4 8%
8 1e2 28.3 26.1 2% 26.9 3% 25.9 4%
8 1e1 32.8 32.5 1% 33.1 0% 32.9 0%
8 2e0 48.1 48.1 1% 48.8 0% 47.8 0%
9 1e2 29.3 28.6 0% 28.6 2% 29.5 -2% 27.1 11%
9 1e1 15.1 15.2 0% 15.3 1% 15.0 1% 15.3 1%
9 2e0 11.3 11.0 2% 11.2 2% 10.6 4% 11.9 -3%
10 1e2 113.3
10 1e1 67.4
10 2e0 91.9
K cardinality
by K cardinality Size (no NA, unsorted)
K Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 1e7
1e2 1e8
1e1 1e7
1e1 1e8
2e0 1e7
2e0 1e8
by K cardinality Question (no NA, unsorted)
K Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 1 1.1 1.2 -1% 1.1 -6% 1.1 0% 1.0 18%
1e2 2 4.2 4.1 6% 4.0 0% 3.8 5% 3.3 26%
1e2 3 4.4 4.7 -7% 4.4 2% 3.8 0% 4.2 7%
1e2 4 3.0 3.1 -6% 2.9 0% 2.9 0% 2.5 15%
1e2 5 7.9 7.9 -1% 7.9 1% 7.3 -4% 8.4 -6%
1e2 6 8.8 8.7 -3% 8.6 0% 8.6 0%
1e2 7 3.7 3.6 1% 3.5 -3% 3.4 -7%
1e2 8 28.3 26.1 2% 26.9 3% 25.9 4%
1e2 9 29.3 28.6 0% 28.6 2% 29.5 -2% 27.1 11%
1e2 10 113.3
1e1 1 1.1 1.1 2% 1.0 4% 1.1 0% 1.0 12%
1e1 2 3.2 3.3 -5% 3.5 -3% 2.9 4% 2.6 13%
1e1 3 8.4 8.6 2% 8.6 0% 8.1 4% 10.8 -24%
1e1 4 2.9 2.9 1% 2.9 1% 2.9 3% 2.5 16%
1e1 5 15.9 16.7 -1% 17.3 -5% 15.8 1% 15.9 -2%
1e1 6 6.2 6.3 0% 6.3 -1% 6.1 2%
1e1 7 8.2 8.4 -1% 8.3 -2% 7.8 8%
1e1 8 32.8 32.5 1% 33.1 0% 32.9 0%
1e1 9 15.1 15.2 0% 15.3 1% 15.0 1% 15.3 1%
1e1 10 67.4
2e0 1 1.1 1.1 3% 1.1 4% 1.2 -1% 1.0 17%
2e0 2 3.0 3.0 -3% 3.2 -3% 2.8 2% 2.6 15%
2e0 3 14.6 14.7 0% 15.8 -3% 13.4 7% 30.1 -48%
2e0 4 2.9 3.0 -3% 2.9 0% 2.9 0% 2.5 13%
2e0 5 32.6 31.9 2% 33.8 0% 31.7 3% 30.2 7%
2e0 6 5.6 5.6 2% 5.9 0% 5.5 4%
2e0 7 17.8 17.7 1% 17.9 0% 16.4 8%
2e0 8 48.1 48.1 1% 48.8 0% 47.8 0%
2e0 9 11.3 11.0 2% 11.2 2% 10.6 4% 11.9 -3%
2e0 10 91.9
NA fraction
by NA fraction Size (k=1e2, unsorted)
NA fraction Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7
0 1e8
Sortedness
by Sortedness (k=1e2, no NA)
Sorted Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7
0 1e8
1 1e7
1 1e8

join

Overview
by Question (no NA, unsorted)
Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 41.6 45.5 -3% 43.5 0% 46.6 5%
2 68.3 67.2 1% 67.4 0% 62.8 20%
3 37.2 37.7 0% 37.7 -1% 30.3 17%
4 60.2 60.1 0% 59.5 0% 48.1 33%
5 197.0 196.7 0% 194.8 0% 381.8 -52%
by Size (no NA, unsorted)
Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e7 9.9 9.8 1% 9.9 0% 14.7 10%
1e8 151.7 153.1 -1% 151.3 0% 213.2 -1%
by NA fraction (unsorted)
NA fraction Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 80.8 81.5 0% 80.6 0% 113.9 4%
by Sortedness (no NA)
Sorted Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 80.8 81.5 0% 80.6 0% 113.9 4%
Question
by Question Size (no NA, unsorted)
Q Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e7 4.4 4.2 3% 4.3 2% 3.6 22%
1 1e8 78.7 86.9 -9% 82.7 -4% 89.7 -12%
2 1e7 9.6 9.4 2% 9.7 0% 7.2 33%
2 1e8 126.9 125.1 1% 125.1 1% 118.5 7%
3 1e7 5.3 5.3 0% 5.3 0% 4.7 11%
3 1e8 69.0 70.2 -1% 70.0 -1% 55.9 23%
4 1e7 7.9 7.8 1% 7.8 0% 5.6 41%
4 1e8 112.5 112.4 0% 111.1 1% 90.5 24%
5 1e7 22.4 22.4 0% 22.3 0% 52.2 -57%
5 1e8 371.5 371.0 0% 367.4 1% 711.4 -47%
NA fraction
by NA fraction Size (unsorted)
NA fraction Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 9.9 9.8 1% 9.9 0% 14.7 10%
0 1e8 151.7 153.1 -1% 151.3 0% 213.2 -1%
Sortedness
by Sortedness Size (no NA)
Sorted Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 9.9 9.8 1% 9.9 0% 14.7 10%
0 1e8 151.7 153.1 -1% 151.3 0% 213.2 -1%

pydatatable

groupby

Overview
by Question (k=1e2, no NA, unsorted)
Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 15.7 14.8 -5% 12.9 6% 15.4 -17%
2 19.3 21.0 -4% 20.0 -3% 70.5 -81%
3 43.1 56.4 -21% 49.4 -2% 605.2 -94%
4 41.0 39.1 0% 37.7 1% 17.4 192%
5 9.4 10.1 -10% 9.5 0% 34.6 -67%
6 88.2 103.0 -13% 92.0 0%
7 43.8 50.5 -8% 44.5 0%
8 96.5 109.5 -21% 93.6 0%
9 6.9 7.2 -12% 7.0 -4%
10 229.8 264.4 -8% 232.6 7%
by Size (k=1e2, no NA, unsorted)
Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e7 1.8 2.0 -13% 1.7 0%
1e8 20.1 24.0 -10% 20.2 0%
1e9 156.2 176.8 -7% 157.9 0%
by K cardinality (no NA, unsorted)
K Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 59.4 67.6 -10% 59.9 0%
1e1 60.0 68.6 -12% 61.0 0%
2e0 77.3 89.8 -6% 79.3 0%
by NA fraction (k=1e2, unsorted)
NA fraction Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 59.4 67.6 -10% 59.9 0%
by Sortedness (k=1e2, no NA)
Sorted Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 59.4 67.6 -10% 59.9 0%
1 46.4 52.3 -9% 47.2 -1%
Question
by Question Size (k=1e2, no NA, unsorted)
Q Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e7 0.3 0.4 -16% 0.4 -3% 0.5 -31%
1 1e8 3.6 3.9 -6% 3.8 -3% 4.9 -25%
1 1e9 43.0 40.2 7% 34.6 24% 40.8 5%
2 1e7 0.6 0.6 1% 0.7 -8% 6.5 -90%
2 1e8 5.6 6.0 -6% 5.4 4% 33.8 -83%
2 1e9 51.6 56.3 -8% 54.0 -4% 171.3 -69%
3 1e7 1.1 1.5 -28% 1.0 10% 28.6 -96%
3 1e8 10.2 11.4 -10% 10.8 -5% 242.3 -95%
3 1e9 118.0 156.4 -24% 136.4 -13% 1544.8 -92%
4 1e7 0.9 0.9 0% 0.9 -1% 0.3 205%
4 1e8 10.3 11.2 -8% 10.8 -4% 3.0 244%
4 1e9 111.7 105.2 6% 101.5 10% 48.8 128%
5 1e7 0.3 0.3 -18% 0.3 -3% 0.5 -47%
5 1e8 3.7 3.9 -5% 3.5 4% 30.1 -87%
5 1e9 24.3 26.1 -7% 24.7 -1% 73.3 -66%
6 1e7 1.4 1.5 -5% 1.2 11%
6 1e8 65.0 85.2 -23% 68.9 -5%
6 1e9 198.2 222.3 -10% 205.7 -3%
7 1e7 1.1 1.1 -1% 1.1 -1%
7 1e8 10.0 11.1 -10% 9.9 0%
7 1e9 120.4 139.4 -13% 122.5 -1%
8 1e7 2.7 4.4 -37% 3.0 -8%
8 1e8 26.6 31.3 -15% 25.9 2%
8 1e9 260.3 292.9 -11% 251.8 3%
9 1e7 0.2 0.3 -26% 0.2 -12%
9 1e8 1.8 2.0 -6% 1.8 0%
9 1e9 18.7 19.3 -3% 18.9 -1%
10 1e7 9.5 9.5 0% 7.9 20% 608.7 -98%
10 1e8 64.4 74.0 -13% 61.1 5%
10 1e9 615.6 709.5 -13% 628.9 -2%
by Question K cardinality (no NA, unsorted)
Q K Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e2 15.7 14.8 -5% 12.9 6% 15.4 -17%
1 1e1 6.6 7.7 -11% 7.6 -7% 9.4 -18%
1 2e0 6.4 6.7 -2% 6.6 -3% 7.5 -7%
2 1e2 19.3 21.0 -4% 20.0 -3% 70.5 -81%
2 1e1 19.7 20.2 -9% 19.2 -2% 26.9 -41%
2 2e0 9.9 9.7 3% 8.8 4% 12.0 -28%
3 1e2 43.1 56.4 -21% 49.4 -2% 605.2 -94%
3 1e1 102.4 117.1 -15% 105.5 -3%
3 2e0 197.7 239.6 -12% 198.3 1%
4 1e2 41.0 39.1 0% 37.7 1% 17.4 192%
4 1e1 12.9 14.1 -10% 13.5 -5%
4 2e0 11.6 11.8 -3% 11.9 -4%
5 1e2 9.4 10.1 -10% 9.5 0% 34.6 -67%
5 1e1 50.6 58.0 -11% 53.2 0%
5 2e0 25.5 29.1 -13% 26.4 0%
6 1e2 88.2 103.0 -13% 92.0 0%
6 1e1 29.4 30.8 -5% 29.7 6%
6 2e0 12.4 12.7 -2% 12.1 5%
7 1e2 43.8 50.5 -8% 44.5 0%
7 1e1 98.7 113.8 -13% 98.0 0%
7 2e0 194.7 221.7 -11% 195.9 0%
8 1e2 96.5 109.5 -21% 93.6 0%
8 1e1 48.0 55.9 -23% 49.5 0%
8 2e0 26.9 28.9 -6% 26.5 1%
9 1e2 6.9 7.2 -12% 7.0 -4%
9 1e1 6.2 6.5 -7% 6.6 -2%
9 2e0 5.8 6.0 0% 5.9 1%
10 1e2 229.8 264.4 -8% 232.6 7%
10 1e1 225.3 261.7 -14% 227.6 3%
10 2e0 282.3 331.7 -13% 300.5 -5%
K cardinality
by K cardinality Size (no NA, unsorted)
K Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 1e7 1.8 2.0 -13% 1.7 0%
1e2 1e8 20.1 24.0 -10% 20.2 0%
1e2 1e9 156.2 176.8 -7% 157.9 0%
1e1 1e7 1.6 1.8 -12% 1.4 3%
1e1 1e8 13.0 15.4 -14% 13.4 -3%
1e1 1e9 165.4 188.5 -9% 168.2 -3%
2e0 1e7 2.0 2.2 -8% 2.0 0%
2e0 1e8 19.2 21.4 -3% 19.5 1%
2e0 1e9 210.8 245.7 -7% 216.4 0%
by K cardinality Question (no NA, unsorted)
K Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 1 15.7 14.8 -5% 12.9 6% 15.4 -17%
1e2 2 19.3 21.0 -4% 20.0 -3% 70.5 -81%
1e2 3 43.1 56.4 -21% 49.4 -2% 605.2 -94%
1e2 4 41.0 39.1 0% 37.7 1% 17.4 192%
1e2 5 9.4 10.1 -10% 9.5 0% 34.6 -67%
1e2 6 88.2 103.0 -13% 92.0 0%
1e2 7 43.8 50.5 -8% 44.5 0%
1e2 8 96.5 109.5 -21% 93.6 0%
1e2 9 6.9 7.2 -12% 7.0 -4%
1e2 10 229.8 264.4 -8% 232.6 7%
1e1 1 6.6 7.7 -11% 7.6 -7% 9.4 -18%
1e1 2 19.7 20.2 -9% 19.2 -2% 26.9 -41%
1e1 3 102.4 117.1 -15% 105.5 -3%
1e1 4 12.9 14.1 -10% 13.5 -5%
1e1 5 50.6 58.0 -11% 53.2 0%
1e1 6 29.4 30.8 -5% 29.7 6%
1e1 7 98.7 113.8 -13% 98.0 0%
1e1 8 48.0 55.9 -23% 49.5 0%
1e1 9 6.2 6.5 -7% 6.6 -2%
1e1 10 225.3 261.7 -14% 227.6 3%
2e0 1 6.4 6.7 -2% 6.6 -3% 7.5 -7%
2e0 2 9.9 9.7 3% 8.8 4% 12.0 -28%
2e0 3 197.7 239.6 -12% 198.3 1%
2e0 4 11.6 11.8 -3% 11.9 -4%
2e0 5 25.5 29.1 -13% 26.4 0%
2e0 6 12.4 12.7 -2% 12.1 5%
2e0 7 194.7 221.7 -11% 195.9 0%
2e0 8 26.9 28.9 -6% 26.5 1%
2e0 9 5.8 6.0 0% 5.9 1%
2e0 10 282.3 331.7 -13% 300.5 -5%
NA fraction
by NA fraction Size (k=1e2, unsorted)
NA fraction Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 1.8 2.0 -13% 1.7 0%
0 1e8 20.1 24.0 -10% 20.2 0%
0 1e9 156.2 176.8 -7% 157.9 0%
Sortedness
by Sortedness Size (k=1e2, no NA)
Sorted Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 1.8 2.0 -13% 1.7 0%
0 1e8 20.1 24.0 -10% 20.2 0%
0 1e9 156.2 176.8 -7% 157.9 0%
1 1e7 1.5 1.7 -9% 1.4 -2%
1 1e8 17.5 20.7 -11% 17.6 0%
1 1e9 120.3 134.5 -8% 122.7 0%

join

Overview
by Question (no NA, unsorted)
Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 291.3 329.2 2% 13.9 3797% 14.4 3475%
2 314.9 473.1 2% 14.7 4072% 15.6 4013%
3 227.8 291.0 -18% 5.6 3904% 5.7 4510%
4 350.3 451.3 -2% 57.2 2096% 57.3 2136%
5 238.8 261.1
by Size (no NA, unsorted)
Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e7 14.8 14.3 11% 0.8 4591% 1.5 4624%
1e8 88.7 116.0 -19% 13.4 2159% 10.7 2329%
1e9 183.9 200.3
by NA fraction (unsorted)
NA fraction Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 66.0 70.8
by Sortedness (no NA)
Sorted Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 66.0 70.8
Question
by Question Size (no NA, unsorted)
Q Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e7 13.9 11.5 20% 0.2 5958% 0.3 5004%
1 1e8 85.9 85.8 0% 2.4 3550% 2.3 3624%
1 1e9 773.9 890.3 -13% 39.0 1884% 40.8 1799%
2 1e7 22.6 14.1 60% 0.3 7252% 0.3 7181%
2 1e8 99.9 121.8 -17% 3.2 3043% 3.2 3056%
2 1e9 822.1 1283.3 -35% 40.7 1920% 43.2 1801%
3 1e7 7.5 7.2 4% 0.1 5018% 0.1 6693%
3 1e8 34.8 56.3 -38% 1.3 2591% 1.2 2923%
3 1e9 641.1 809.6 -20% 15.2 4104% 16.0 3913%
4 1e7 16.1 13.6 17% 0.4 4360% 0.4 4126%
4 1e8 84.2 84.0 0% 5.4 1456% 4.4 1816%
4 1e9 950.6 1256.3 -24% 166.0 472% 167.2 468%
5 1e7 14.1 25.0 -43% 3.0 368% 6.4 119%
5 1e8 138.9 232.0 -40% 54.7 153% 42.3 228%
5 1e9 658.6 734.5
NA fraction
by NA fraction Size (unsorted)
NA fraction Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 14.8 14.3 11% 0.8 4591% 1.5 4624%
0 1e8 88.7 116.0 -19% 13.4 2159% 10.7 2329%
0 1e9 183.9 200.3
Sortedness
by Sortedness Size (no NA)
Sorted Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 14.8 14.3 11% 0.8 4591% 1.5 4624%
0 1e8 88.7 116.0 -19% 13.4 2159% 10.7 2329%
0 1e9 183.9 200.3

spark

groupby

Overview
by Question (k=1e2, no NA, unsorted)
Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 7.6 10.2 -23% 6.0 30% 7.4 0%
2 9.9 10.1 -11% 9.9 -4% 9.7 4%
3 28.3 27.9 3% 31.3 -5% 186.3 -27%
4 3.5 3.5 2% 3.5 2% 4.0 -13%
5 21.5 21.9 -1% 22.0 -3% 65.0 -23%
7 28.5 25.5 12% 26.5 4%
8 47.4 47.6 -1% 52.3 -3%
9 9.3 9.4 -2% 9.7 -17% 12.8 -11%
10 230.6 249.6 0% 280.2 -3%
by Size (k=1e2, no NA, unsorted)
Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e7 2.0 2.1 -4% 2.2 -7%
1e8 9.1 9.7 -3% 8.6 7%
1e9 117.8 123.4 0% 136.4 0%
by K cardinality (no NA, unsorted)
K Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 43.0 45.1 -2% 49.1 0%
1e1 47.0 67.7 -4% 45.4 1%
2e0 48.0 61.1 1% 46.9 -1%
by NA fraction (k=1e2, unsorted)
NA fraction Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 43.0 45.1 -2% 49.1 0%
by Sortedness (k=1e2, no NA)
Sorted Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 43.0 45.1 -2% 49.1 0%
1 46.3 45.5 6% 42.4 8%
Question
by Question Size (k=1e2, no NA, unsorted)
Q Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e7 2.1 2.2 -3% 1.7 28% 2.2 -3%
1 1e8 3.0 12.2 -75% 2.2 37% 3.0 0%
1 1e9 17.6 16.4 7% 14.1 24% 16.9 3%
2 1e7 1.5 2.3 -34% 1.7 -12% 1.4 7%
2 1e8 3.7 3.7 0% 3.8 -1% 3.6 3%
2 1e9 24.5 24.4 0% 24.4 0% 24.1 1%
3 1e7 1.7 1.7 -1% 2.0 -14% 1.7 0%
3 1e8 7.0 6.3 10% 6.3 9% 6.7 4%
3 1e9 76.4 75.7 0% 85.5 -10% 550.6 -86%
4 1e7 0.8 0.8 7% 0.7 13% 0.9 -8%
4 1e8 1.2 1.2 0% 1.3 -6% 1.6 -21%
4 1e9 8.6 8.5 0% 8.5 0% 9.5 -10%
5 1e7 1.3 1.4 -4% 1.5 -11% 1.4 -5%
5 1e8 5.0 5.0 0% 4.8 5% 4.8 4%
5 1e9 58.1 59.3 -1% 59.8 -2% 188.8 -69%
7 1e7 1.6 1.5 6% 1.7 -9%
7 1e8 6.8 5.7 18% 5.9 14%
7 1e9 77.1 69.3 11% 71.8 7%
8 1e7 2.5 2.5 -3% 2.5 -3%
8 1e8 10.2 10.3 -1% 9.9 3%
8 1e9 129.6 130.0 0% 144.5 -10%
9 1e7 1.2 1.4 -13% 2.8 -56% 1.4 -10%
9 1e8 3.2 3.0 8% 3.1 2% 3.0 6%
9 1e9 23.4 23.7 -1% 23.2 0% 33.9 -30%
10 1e7 5.2 5.0 3% 5.1 2% 5.2 1%
10 1e8 41.6 40.4 2% 39.8 4% 40.0 3%
10 1e9 645.1 703.5 -8% 795.8 -18%
by Question K cardinality (no NA, unsorted)
Q K Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e2 7.6 10.2 -23% 6.0 30% 7.4 0%
1 1e1 5.2 5.6 0% 6.0 -17% 6.0 -3%
1 2e0 5.3 5.3 8% 5.6 -12% 6.4 -2%
2 1e2 9.9 10.1 -11% 9.9 -4% 9.7 4%
2 1e1 7.2 8.1 -14% 7.4 -3% 9.4 -6%
2 2e0 5.8 5.5 22% 5.7 7% 5.8 7%
3 1e2 28.3 27.9 3% 31.3 -5% 186.3 -27%
3 1e1 35.1 46.8 -13% 35.9 -2% 174.8 -26%
3 2e0 52.8 61.5 0% 55.6 4% 305.2 -28%
4 1e2 3.5 3.5 2% 3.5 2% 4.0 -13%
4 1e1 3.5 3.2 20% 3.3 18% 3.2 17%
4 2e0 3.2 3.3 2% 3.3 -4% 4.1 -13%
5 1e2 21.5 21.9 -1% 22.0 -3% 65.0 -23%
5 1e1 30.6 40.3 -3% 31.1 0% 65.8 -30%
5 2e0 44.5 51.6 -5% 46.0 -10% 94.5 -17%
7 1e2 28.5 25.5 12% 26.5 4%
7 1e1 33.5 51.0 -16% 33.0 0%
7 2e0 45.6 54.6 -8% 47.5 -8%
8 1e2 47.4 47.6 -1% 52.3 -3%
8 1e1 47.8 56.8 0% 48.4 9%
8 2e0 49.7 53.2 -4% 51.1 0%
9 1e2 9.3 9.4 -2% 9.7 -17% 12.8 -11%
9 1e1 6.5 6.6 0% 6.5 4% 7.0 0%
9 2e0 5.4 5.1 8% 5.2 5% 7.2 -13%
10 1e2 230.6 249.6 0% 280.2 -3%
10 1e1 253.3 391.2 -10% 236.6 6% 467.2 -17%
10 2e0 219.9 309.7 -10% 201.8 5%
K cardinality
by K cardinality Size (no NA, unsorted)
K Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 1e7 2.0 2.1 -4% 2.2 -7%
1e2 1e8 9.1 9.7 -3% 8.6 7%
1e2 1e9 117.8 123.4 0% 136.4 0%
1e1 1e7 2.2 2.2 4% 2.1 5%
1e1 1e8 10.0 10.1 0% 9.7 1%
1e1 1e9 128.7 190.9 -17% 124.3 -1%
2e0 1e7 2.3 2.2 12% 2.3 0%
2e0 1e8 11.5 11.6 0% 11.7 -4%
2e0 1e9 130.3 169.4 -9% 126.6 0%
by K cardinality Question (no NA, unsorted)
K Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 1 7.6 10.2 -23% 6.0 30% 7.4 0%
1e2 2 9.9 10.1 -11% 9.9 -4% 9.7 4%
1e2 3 28.3 27.9 3% 31.3 -5% 186.3 -27%
1e2 4 3.5 3.5 2% 3.5 2% 4.0 -13%
1e2 5 21.5 21.9 -1% 22.0 -3% 65.0 -23%
1e2 7 28.5 25.5 12% 26.5 4%
1e2 8 47.4 47.6 -1% 52.3 -3%
1e2 9 9.3 9.4 -2% 9.7 -17% 12.8 -11%
1e2 10 230.6 249.6 0% 280.2 -3%
1e1 1 5.2 5.6 0% 6.0 -17% 6.0 -3%
1e1 2 7.2 8.1 -14% 7.4 -3% 9.4 -6%
1e1 3 35.1 46.8 -13% 35.9 -2% 174.8 -26%
1e1 4 3.5 3.2 20% 3.3 18% 3.2 17%
1e1 5 30.6 40.3 -3% 31.1 0% 65.8 -30%
1e1 7 33.5 51.0 -16% 33.0 0%
1e1 8 47.8 56.8 0% 48.4 9%
1e1 9 6.5 6.6 0% 6.5 4% 7.0 0%
1e1 10 253.3 391.2 -10% 236.6 6% 467.2 -17%
2e0 1 5.3 5.3 8% 5.6 -12% 6.4 -2%
2e0 2 5.8 5.5 22% 5.7 7% 5.8 7%
2e0 3 52.8 61.5 0% 55.6 4% 305.2 -28%
2e0 4 3.2 3.3 2% 3.3 -4% 4.1 -13%
2e0 5 44.5 51.6 -5% 46.0 -10% 94.5 -17%
2e0 7 45.6 54.6 -8% 47.5 -8%
2e0 8 49.7 53.2 -4% 51.1 0%
2e0 9 5.4 5.1 8% 5.2 5% 7.2 -13%
2e0 10 219.9 309.7 -10% 201.8 5%
NA fraction
by NA fraction Size (k=1e2, unsorted)
NA fraction Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 2.0 2.1 -4% 2.2 -7%
0 1e8 9.1 9.7 -3% 8.6 7%
0 1e9 117.8 123.4 0% 136.4 0%
Sortedness
by Sortedness Size (k=1e2, no NA)
Sorted Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 2.0 2.1 -4% 2.2 -7%
0 1e8 9.1 9.7 -3% 8.6 7%
0 1e9 117.8 123.4 0% 136.4 0%
1 1e7 2.1 2.2 0% 2.2 -2%
1 1e8 8.9 8.7 21% 8.3 22%
1 1e9 128.0 125.6 -2% 116.7 5%

join

Overview
by Question (no NA, unsorted)
Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 267.8 228.7 8% 206.8 13%
2 617.4 630.5 0% 619.1 1%
3 688.3 836.0 -5% 501.2 14%
4 606.4 640.8
5 45.4 45.7 -2% 45.1 2%
by Size (no NA, unsorted)
Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e7 6.1 6.2 1% 5.8 7%
1e8 51.2 51.1 0% 50.8 0%
1e9 1677.5 1427.8
by NA fraction (unsorted)
NA fraction Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 499.7 428.1
by Sortedness (no NA)
Sorted Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 499.7 428.1
Question
by Question Size (no NA, unsorted)
Q Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e7 4.7 4.5 6% 4.3 9%
1 1e8 36.9 37.1 0% 37.1 0%
1 1e9 761.8 644.4 18% 578.8 31%
2 1e7 4.2 4.2 0% 4.1 4%
2 1e8 45.8 45.2 1% 45.1 1%
2 1e9 1802.0 1842.0 -2% 1808.2 0%
3 1e7 4.8 4.8 0% 4.6 3%
3 1e8 49.6 49.1 0% 48.8 1%
3 1e9 2010.5 2454.1 -18% 1450.3 38%
4 1e7 5.0 4.8 3% 4.3 14%
4 1e8 44.8 44.8 0% 44.2 1%
4 1e9 1769.6 1873.7
5 1e7 11.9 12.5 -4% 11.4 4%
5 1e8 78.9 78.9 0% 78.9 0%
NA fraction
by NA fraction Size (unsorted)
NA fraction Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 6.1 6.2 1% 5.8 7%
0 1e8 51.2 51.1 0% 50.8 0%
0 1e9 1677.5 1427.8
Sortedness
by Sortedness Size (no NA)
Sorted Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 6.1 6.2 1% 5.8 7%
0 1e8 51.2 51.1 0% 50.8 0%
0 1e9 1677.5 1427.8

cudf

groupby

Overview
by Question (k=1e2, no NA, unsorted)
Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 0.0 0.1 -66%
2 0.0 0.1 -40%
3 0.1 1.0 -85%
4 0.1 0.3 -52%
5 0.1 0.1 -10%
6 0.5
10 0.5 0.5 3%
by Size (k=1e2, no NA, unsorted)
Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e7 0.2
by K cardinality (no NA, unsorted)
K Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 0.2
1e1 0.2
2e0 0.2
by NA fraction (k=1e2, unsorted)
NA fraction Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 0.2
by Sortedness (k=1e2, no NA)
Sorted Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 0.2
1 0.2
Question
by Question Size (k=1e2, no NA, unsorted)
Q Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e7 0.0 0.1 -66%
2 1e7 0.0 0.1 -40%
3 1e7 0.1 1.0 -85%
4 1e7 0.1 0.3 -52%
5 1e7 0.1 0.1 -10%
6 1e7 0.5
10 1e7 0.5 0.5 3%
by Question K cardinality (no NA, unsorted)
Q K Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e2 0.0 0.1 -66%
1 1e1 0.0 0.0 -20%
1 2e0 0.0 0.0 -8%
2 1e2 0.0 0.1 -40%
2 1e1 0.0 0.0 17%
2 2e0 0.0 0.0 19%
3 1e2 0.1 1.0 -85%
3 1e1 0.2 0.1 44%
3 2e0 0.2 0.2 -1%
4 1e2 0.1 0.3 -52%
4 1e1 0.1 0.0 112%
4 2e0 0.1 0.1 55%
5 1e2 0.1 0.1 -10%
5 1e1 0.1 0.1 -8%
5 2e0 0.1 0.1 -6%
6 1e2 0.5
6 1e1 0.4
6 2e0 0.3
10 1e2 0.5 0.5 3%
10 1e1 0.6 0.6 3%
10 2e0 0.6 0.7 -3%
K cardinality
by K cardinality Size (no NA, unsorted)
K Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 1e7 0.2
1e1 1e7 0.2
2e0 1e7 0.2
by K cardinality Question (no NA, unsorted)
K Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 1 0.0 0.1 -66%
1e2 2 0.0 0.1 -40%
1e2 3 0.1 1.0 -85%
1e2 4 0.1 0.3 -52%
1e2 5 0.1 0.1 -10%
1e2 6 0.5
1e2 10 0.5 0.5 3%
1e1 1 0.0 0.0 -20%
1e1 2 0.0 0.0 17%
1e1 3 0.2 0.1 44%
1e1 4 0.1 0.0 112%
1e1 5 0.1 0.1 -8%
1e1 6 0.4
1e1 10 0.6 0.6 3%
2e0 1 0.0 0.0 -8%
2e0 2 0.0 0.0 19%
2e0 3 0.2 0.2 -1%
2e0 4 0.1 0.1 55%
2e0 5 0.1 0.1 -6%
2e0 6 0.3
2e0 10 0.6 0.7 -3%
NA fraction
by NA fraction Size (k=1e2, unsorted)
NA fraction Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 0.2
Sortedness
by Sortedness Size (k=1e2, no NA)
Sorted Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 0.2
1 1e7 0.2

join

Overview
by Question (no NA, unsorted)
Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 0.0 2.1 -98%
2 0.0 0.2 -84%
3 0.0 0.8 -94%
4 0.0 0.2 -83%
5 0.2 2.2 -91%
by Size (no NA, unsorted)
Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e7 0.1 1.1 -90%
by NA fraction (unsorted)
NA fraction Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 0.1 1.1 -90%
by Sortedness (no NA)
Sorted Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 0.1 1.1 -90%
Question
by Question Size (no NA, unsorted)
Q Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e7 0.0 2.1 -98%
2 1e7 0.0 0.2 -84%
3 1e7 0.0 0.8 -94%
4 1e7 0.0 0.2 -83%
5 1e7 0.2 2.2 -91%
NA fraction
by NA fraction Size (unsorted)
NA fraction Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 0.1 1.1 -90%
Sortedness
by Sortedness Size (no NA)
Sorted Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 0.1 1.1 -90%

dask

groupby

Overview
by Question (k=1e2, no NA, unsorted)
Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 247.3 322.8 -8% 321.6 -7%
2 249.6 316.6 -5% 312.5 -4%
3 1862.9 1979.3 -6% 1964.6 -2%
4 1.0 1.0 5% 1.1 -4% 1.0 4%
5 4.0 3.9 -5% 4.1 -9% 3.9 -1%
7 71.3 69.3 12% 71.1 7%
8 2013.4 1894.6 5% 1902.4 5%
9 26.9
10 13.4 13.4 0% 13.9 -4% 13.5 -1%
by Size (k=1e2, no NA, unsorted)
Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e7
1e8 575.8 544.9 1% 546.2 0%
1e9 2309.6 2565.1 -16% 2549.2 -16%
by K cardinality (no NA, unsorted)
K Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2
1e1
2e0
by NA fraction (k=1e2, unsorted)
NA fraction Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0
by Sortedness (k=1e2, no NA)
Sorted Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0
1
Question
by Question Size (k=1e2, no NA, unsorted)
Q Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e7 0.1 0.1 2% 0.1 -2% 0.1 16%
1 1e8 0.7 0.7 -3% 0.7 2% 0.6 9%
1 1e9 741.0 967.4 -23% 964.1 -23%
2 1e7 0.2 0.2 3% 0.2 5% 0.2 20%
2 1e8 1.6 1.5 1% 1.6 0% 1.4 11%
2 1e9 747.0 948.1 -21% 935.8 -20%
3 1e7 1.6 1.7 -5% 1.6 -4% 1.4 12%
3 1e8 146.4 156.4 -6% 144.4 1% 144.1 1%
3 1e9 5440.7 5779.9 -5% 5747.6 -5%
4 1e7 0.2 0.2 9% 0.2 -3% 0.2 15%
4 1e8 1.8 1.7 2% 1.9 -5% 1.9 -5%
5 1e7 0.3 0.4 -18% 0.4 -17% 0.3 -6%
5 1e8 7.8 7.3 6% 7.8 0% 7.5 4%
7 1e7 1.7 1.4 23% 1.4 15%
7 1e8 141.0 137.3 2% 140.8 0%
8 1e7 295.2 280.4 5% 278.7 5%
8 1e8 3731.6 3508.9 6% 3526.0 5%
9 1e7 26.9
10 1e7 13.4 13.4 0% 13.9 -4% 13.5 -1%
by Question K cardinality (no NA, unsorted)
Q K Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e2 247.3 322.8 -8% 321.6 -7%
1 1e1 263.9 335.6 -3% 341.1 -4%
1 2e0 261.3 329.8 -6% 330.0 -17%
2 1e2 249.6 316.6 -5% 312.5 -4%
2 1e1 264.1 324.1 -5% 326.2 -6%
2 2e0 264.1 326.2 -6% 353.7 -9%
3 1e2 1862.9 1979.3 -6% 1964.6 -2%
3 1e1 268.9 259.9 2% 251.1 1% 236.9 15%
3 2e0 492.5 509.3 0% 577.0 -5% 402.1 45%
4 1e2 1.0 1.0 5% 1.1 -4% 1.0 4%
4 1e1 1.1 1.0 12% 1.1 -8% 0.9 11%
4 2e0 1.0 1.0 0% 1.0 3% 1.0 4%
5 1e2 4.0 3.9 -5% 4.1 -9% 3.9 -1%
5 1e1 14.5 14.6 0% 14.4 0% 14.9 -3%
5 2e0 34.2 33.8 3% 32.7 2% 35.7 -7%
7 1e2 71.3 69.3 12% 71.1 7%
7 1e1 251.6 242.4 2% 248.9 -1%
7 2e0 482.4 491.9 6% 532.0 -3%
8 1e2 2013.4 1894.6 5% 1902.4 5%
8 1e1 2725.9 2461.0 10% 2665.1 2%
9 1e2 26.9
9 1e1 4.0
9 2e0 20.0
10 1e2 13.4 13.4 0% 13.9 -4% 13.5 -1%
10 1e1 24.5
10 2e0 608.9
K cardinality
by K cardinality Size (no NA, unsorted)
K Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 1e7
1e2 1e8 575.8 544.9 1% 546.2 0%
1e2 1e9 2309.6 2565.1 -16% 2549.2 -16%
1e1 1e7
1e1 1e8 173.6 167.6 4% 166.5 3%
1e1 1e9 790.9 988.5 -19% 999.8 -20%
2e0 1e7
2e0 1e8
2e0 1e9 787.2 983.1 -19% 1024.5 -23%
by K cardinality Question (no NA, unsorted)
K Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 1 247.3 322.8 -8% 321.6 -7%
1e2 2 249.6 316.6 -5% 312.5 -4%
1e2 3 1862.9 1979.3 -6% 1964.6 -2%
1e2 4 1.0 1.0 5% 1.1 -4% 1.0 4%
1e2 5 4.0 3.9 -5% 4.1 -9% 3.9 -1%
1e2 7 71.3 69.3 12% 71.1 7%
1e2 8 2013.4 1894.6 5% 1902.4 5%
1e2 9 26.9
1e2 10 13.4 13.4 0% 13.9 -4% 13.5 -1%
1e1 1 263.9 335.6 -3% 341.1 -4%
1e1 2 264.1 324.1 -5% 326.2 -6%
1e1 3 268.9 259.9 2% 251.1 1% 236.9 15%
1e1 4 1.1 1.0 12% 1.1 -8% 0.9 11%
1e1 5 14.5 14.6 0% 14.4 0% 14.9 -3%
1e1 7 251.6 242.4 2% 248.9 -1%
1e1 8 2725.9 2461.0 10% 2665.1 2%
1e1 9 4.0
1e1 10 24.5
2e0 1 261.3 329.8 -6% 330.0 -17%
2e0 2 264.1 326.2 -6% 353.7 -9%
2e0 3 492.5 509.3 0% 577.0 -5% 402.1 45%
2e0 4 1.0 1.0 0% 1.0 3% 1.0 4%
2e0 5 34.2 33.8 3% 32.7 2% 35.7 -7%
2e0 7 482.4 491.9 6% 532.0 -3%
2e0 9 20.0
2e0 10 608.9
NA fraction
by NA fraction Size (k=1e2, unsorted)
NA fraction Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7
0 1e8 575.8 544.9 1% 546.2 0%
0 1e9 2309.6 2565.1 -16% 2549.2 -16%
Sortedness
by Sortedness Size (k=1e2, no NA)
Sorted Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7
0 1e8 575.8 544.9 1% 546.2 0%
0 1e9 2309.6 2565.1 -16% 2549.2 -16%
1 1e7
1 1e8 564.2 563.9 1% 550.8 -2%
1 1e9 2397.2 2620.5 -15% 2480.4 -13%

join

Overview
by Question (no NA, unsorted)
Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 120.2 111.1 6% 107.6 9%
2 129.2 120.9 2% 113.2 8%
3 122.3 119.5 0% 106.5 9%
4 162.4 135.9 10% 142.9 8%
5 222.8 217.6 2% 219.0 1%
by Size (no NA, unsorted)
Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e7 58.8 57.7 0% 57.6 2%
1e8 249.2 225.9 9% 217.9 14%
by NA fraction (unsorted)
NA fraction Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 143.4 132.5 4% 128.8 8%
by Sortedness (no NA)
Sorted Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 143.4 132.5 4% 128.8 8%
Question
by Question Size (no NA, unsorted)
Q Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e7 17.4 16.6 5% 16.2 7%
1 1e8 222.9 205.6 8% 199.1 11%
2 1e7 17.3 17.7 -2% 17.2 0%
2 1e8 241.0 224.1 7% 209.3 15%
3 1e7 16.0 16.2 -1% 15.5 3%
3 1e8 228.6 222.7 2% 197.6 15%
4 1e7 20.5 20.5 0% 20.2 1%
4 1e8 304.3 251.3 21% 265.6 14%
5 1e7 222.8 217.6 2% 219.0 1%
NA fraction
by NA fraction Size (unsorted)
NA fraction Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 58.8 57.7 0% 57.6 2%
0 1e8 249.2 225.9 9% 217.9 14%
Sortedness
by Sortedness Size (no NA)
Sorted Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 58.8 57.7 0% 57.6 2%
0 1e8 249.2 225.9 9% 217.9 14%

juliadf

groupby

Overview
by Question (k=1e2, no NA, unsorted)
Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 12.2 14.2 -4%
2 4.9 19.6 -63%
3 56.6 131.9 -56%
4 12.8 18.9 -33%
5 75.8 155.4 -48%
6 67.2 71.3 -2%
7 139.9 141.8 -1%
8 144.1 165.3 -3%
9 80.1 93.6 -14%
10 245.0
by Size (k=1e2, no NA, unsorted)
Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e7 1.9 2.2 -20%
1e8 12.4 15.5 -25%
1e9 237.3
by K cardinality (no NA, unsorted)
K Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 83.9
1e1 10.7 12.8 -19%
2e0 16.9 19.3 -21%
by NA fraction (k=1e2, unsorted)
NA fraction Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 83.9
by Sortedness (k=1e2, no NA)
Sorted Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 83.9
1 72.3
Question
by Question Size (k=1e2, no NA, unsorted)
Q Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e7 6.3 5.8 7% 3.5 77%
1 1e8 6.8 6.9 0% 5.4 25%
1 1e9 23.5 29.8 -21%
2 1e7 0.3 0.6 -42% 0.6 -46%
2 1e8 1.2 4.7 -73% 5.5 -77%
2 1e9 13.3 53.6 -75%
3 1e7 1.1 1.8 -43% 1.2 -14%
3 1e8 4.7 15.2 -68% 16.1 -70%
3 1e9 164.1 378.6 -56%
4 1e7 0.7 1.1 -32% 0.8 -9%
4 1e8 2.8 4.3 -34% 4.2 -32%
4 1e9 34.8 51.4 -32%
5 1e7 0.7 1.2 -41% 1.3 -44%
5 1e8 9.3 19.4 -52% 20.5 -54%
5 1e9 217.4 445.5 -51%
6 1e7 2.4 2.3 4%
6 1e8 14.1 15.0 -5%
6 1e9 185.2 196.5 -5%
7 1e7 1.6 1.6 0%
7 1e8 16.4 16.9 -2%
7 1e9 401.8 407.0 -1%
8 1e7 2.0 2.0 0%
8 1e8 23.8 23.1 3%
8 1e9 406.6 470.7 -13%
9 1e7 1.7 2.2 -21% 2.9 -40%
9 1e8 15.2 16.3 -7% 18.1 -16%
9 1e9 223.3 262.2 -14%
10 1e7 2.2 3.3 -32% 3.6 -37%
10 1e8 29.5 33.7 -12% 37.3 -20%
10 1e9 703.2
by Question K cardinality (no NA, unsorted)
Q K Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e2 12.2 14.2 -4%
1 1e1 6.7 6.6 2% 4.7 46%
1 2e0 8.2 8.3 0% 6.3 40%
2 1e2 4.9 19.6 -63%
2 1e1 0.7 1.1 -25% 1.4 -38%
2 2e0 0.8 1.1 -16% 1.6 -33%
3 1e2 56.6 131.9 -56%
3 1e1 9.2 17.9 -51% 19.0 -51%
3 2e0 14.0 26.5 -52% 31.1 -57%
4 1e2 12.8 18.9 -33%
4 1e1 1.9 2.8 -34% 2.6 -24%
4 2e0 2.1 4.0 -44% 3.5 -32%
5 1e2 75.8 155.4 -48%
5 1e1 8.2 16.7 -52% 17.1 -53%
5 2e0 9.9 21.7 -59% 22.3 -60%
6 1e2 67.2 71.3 -2%
6 1e1 6.0 6.1 -3%
6 2e0 7.3 7.9 -10%
7 1e2 139.9 141.8 -1%
7 1e1 17.8 18.6 -4%
7 2e0 29.6 30.9 -9%
8 1e2 144.1 165.3 -3%
8 1e1 28.5 24.1 17%
8 2e0 63.7 52.1 23%
9 1e2 80.1 93.6 -14%
9 1e1 6.0 6.8 -19% 8.6 -39%
9 2e0 6.1 6.8 -18% 10.2 -46%
10 1e2 245.0
10 1e1 21.7 27.7 -26% 28.9 -33%
10 2e0 27.0 33.8 -31% 47.4 -50%
K cardinality
by K cardinality Size (no NA, unsorted)
K Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 1e7 1.9 2.2 -20%
1e2 1e8 12.4 15.5 -25%
1e2 1e9 237.3
1e1 1e7 2.2 2.6 -20%
1e1 1e8 19.2 23.1 -19%
2e0 1e7 3.1 3.9 -24%
2e0 1e8 30.6 34.7 -19%
by K cardinality Question (no NA, unsorted)
K Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 1 12.2 14.2 -4%
1e2 2 4.9 19.6 -63%
1e2 3 56.6 131.9 -56%
1e2 4 12.8 18.9 -33%
1e2 5 75.8 155.4 -48%
1e2 6 67.2 71.3 -2%
1e2 7 139.9 141.8 -1%
1e2 8 144.1 165.3 -3%
1e2 9 80.1 93.6 -14%
1e2 10 245.0
1e1 1 6.7 6.6 2% 4.7 46%
1e1 2 0.7 1.1 -25% 1.4 -38%
1e1 3 9.2 17.9 -51% 19.0 -51%
1e1 4 1.9 2.8 -34% 2.6 -24%
1e1 5 8.2 16.7 -52% 17.1 -53%
1e1 6 6.0 6.1 -3%
1e1 7 17.8 18.6 -4%
1e1 8 28.5 24.1 17%
1e1 9 6.0 6.8 -19% 8.6 -39%
1e1 10 21.7 27.7 -26% 28.9 -33%
2e0 1 8.2 8.3 0% 6.3 40%
2e0 2 0.8 1.1 -16% 1.6 -33%
2e0 3 14.0 26.5 -52% 31.1 -57%
2e0 4 2.1 4.0 -44% 3.5 -32%
2e0 5 9.9 21.7 -59% 22.3 -60%
2e0 6 7.3 7.9 -10%
2e0 7 29.6 30.9 -9%
2e0 8 63.7 52.1 23%
2e0 9 6.1 6.8 -18% 10.2 -46%
2e0 10 27.0 33.8 -31% 47.4 -50%
NA fraction
by NA fraction Size (k=1e2, unsorted)
NA fraction Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 1.9 2.2 -20%
0 1e8 12.4 15.5 -25%
0 1e9 237.3
Sortedness
by Sortedness Size (k=1e2, no NA)
Sorted Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 1.9 2.2 -20%
0 1e8 12.4 15.5 -25%
0 1e9 237.3
1 1e7 1.8 2.1 -17%
1 1e8 11.9 14.9 -21%
1 1e9 203.3

join

Overview
by Question (no NA, unsorted)
Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 168.6 203.2 -33%
2 185.1 218.0 -31%
3 219.9 265.7 -32%
4 189.4 220.6 -30%
5 359.3 434.8 -26%
by Size (no NA, unsorted)
Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e7 14.6 26.9 -46%
1e8 434.3 510.0 -14%
by NA fraction (unsorted)
NA fraction Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 224.5 268.5 -30%
by Sortedness (no NA)
Sorted Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 224.5 268.5 -30%
Question
by Question Size (no NA, unsorted)
Q Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e7 12.0 24.7 -51%
1 1e8 325.2 381.8 -14%
2 1e7 10.4 20.7 -49%
2 1e8 359.8 415.2 -13%
3 1e7 15.4 30.4 -49%
3 1e8 424.5 501.0 -15%
4 1e7 10.5 20.1 -47%
4 1e8 368.2 421.1 -12%
5 1e7 24.5 38.5 -36%
5 1e8 694.0 831.1 -16%
NA fraction
by NA fraction Size (unsorted)
NA fraction Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 14.6 26.9 -46%
0 1e8 434.3 510.0 -14%
Sortedness
by Sortedness Size (no NA)
Sorted Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 14.6 26.9 -46%
0 1e8 434.3 510.0 -14%

clickhouse

groupby

Overview
by Question (k=1e2, no NA, unsorted)
Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 85.1 31.1 45% 15.4 173%
2 3.4 10.9 -30% 7.4 -16%
3 7.2 36.8 -11% 33.4 -29%
4 17.2 22.8 -8% 20.2 -16%
5 10.9 14.3 -12% 13.6 -19%
6 15.6 12.8 37%
7 19.0 15.2 53%
8 44.4 42.8 2%
9 37.0 17.5 52%
10 9.3 9.8 -3%
by Size (k=1e2, no NA, unsorted)
Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e7 0.4 0.4 33%
1e8 3.1 3.4 -9%
1e9 78.1 66.1 15%
by K cardinality (no NA, unsorted)
K Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 25.5 21.8 13%
1e1 25.9 17.4 76%
2e0 23.5
by NA fraction (k=1e2, unsorted)
NA fraction Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 25.5 21.8 13%
by Sortedness (k=1e2, no NA)
Sorted Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 25.5 21.8 13%
1 8.1 9.0 -11%
Question
by Question Size (k=1e2, no NA, unsorted)
Q Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e7 0.1 0.2 -32% 0.1 93%
1 1e8 0.3 0.3 -5% 0.4 -28%
1 1e9 254.9 92.7 174% 45.8 457%
2 1e7 0.1 0.1 -9% 0.1 5%
2 1e8 0.9 1.1 -11% 0.9 1%
2 1e9 9.0 31.6 -71% 21.1 -57%
3 1e7 0.2 0.1 65% 0.2 30%
3 1e8 1.1 1.4 -18% 1.8 -39%
3 1e9 20.3 109.0 -81% 98.1 -79%
4 1e7 0.0 0.0 -4% 0.0 -15%
4 1e8 0.3 0.2 3% 0.3 -18%
4 1e9 51.2 68.0 -24% 60.2 -15%
5 1e7 0.1 0.1 -7% 0.1 -7%
5 1e8 1.1 1.1 -4% 1.5 -31%
5 1e9 31.7 41.7 -24% 39.2 -19%
6 1e7 0.5 0.2 131%
6 1e8 1.1 1.9 -42%
6 1e9 45.4 36.4 24%
7 1e7 0.4 0.2 138%
7 1e8 1.1 1.2 -3%
7 1e9 55.5 44.1 25%
8 1e7 0.9 0.8 13%
8 1e8 6.9 7.6 -9%
8 1e9 125.4 119.9 4%
9 1e7 0.2 0.2 42%
9 1e8 1.0 1.0 0%
9 1e9 109.8 51.3 114%
10 1e7 1.7 1.8 -1%
10 1e8 16.9 17.8 -5%
by Question K cardinality (no NA, unsorted)
Q K Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e2 85.1 31.1 45% 15.4 173%
1 1e1 14.9 0.8 658% 40.7 -30%
1 2e0 10.5 0.8 483%
2 1e2 3.4 10.9 -30% 7.4 -16%
2 1e1 9.1 4.1 10% 7.1 -24%
2 2e0 4.3 4.2 -34%
3 1e2 7.2 36.8 -11% 33.4 -29%
3 1e1 83.0 26.4 71% 47.2 15%
3 2e0 69.3 40.7 21%
4 1e2 17.2 22.8 -8% 20.2 -16%
4 1e1 24.5 15.5 23% 18.6 4%
4 2e0 23.1 20.5 -21%
5 1e2 10.9 14.3 -12% 13.6 -19%
5 1e1 15.6 18.8 -17% 19.3 -13%
5 2e0 21.9 26.3 -7%
6 1e2 15.6 12.8 37%
6 1e1 14.4 9.6 2%
6 2e0 5.7 8.7 -41%
7 1e2 19.0 15.2 53%
7 1e1 25.9 19.9 5%
7 2e0 34.4 26.2 10%
8 1e2 44.4 42.8 2%
8 1e1 31.3 38.3 -10%
8 2e0 33.3
9 1e2 37.0 17.5 52%
9 1e1 25.2 28.3 0%
9 2e0 18.5
10 1e2 9.3 9.8 -3%
10 1e1 9.0 9.9 -11%
10 2e0 9.3 9.3 -10%
K cardinality
by K cardinality Size (no NA, unsorted)
K Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 1e7 0.4 0.4 33%
1e2 1e8 3.1 3.4 -9%
1e2 1e9 78.1 66.1 15%
1e1 1e7 0.3 0.4 -15%
1e1 1e8 3.2 3.5 -9%
1e1 1e9 79.4 51.8 272%
2e0 1e7 0.4 0.5 -21%
2e0 1e8 4.2 4.5 -23%
2e0 1e9 70.6
by K cardinality Question (no NA, unsorted)
K Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 1 85.1 31.1 45% 15.4 173%
1e2 2 3.4 10.9 -30% 7.4 -16%
1e2 3 7.2 36.8 -11% 33.4 -29%
1e2 4 17.2 22.8 -8% 20.2 -16%
1e2 5 10.9 14.3 -12% 13.6 -19%
1e2 6 15.6 12.8 37%
1e2 7 19.0 15.2 53%
1e2 8 44.4 42.8 2%
1e2 9 37.0 17.5 52%
1e2 10 9.3 9.8 -3%
1e1 1 14.9 0.8 658% 40.7 -30%
1e1 2 9.1 4.1 10% 7.1 -24%
1e1 3 83.0 26.4 71% 47.2 15%
1e1 4 24.5 15.5 23% 18.6 4%
1e1 5 15.6 18.8 -17% 19.3 -13%
1e1 6 14.4 9.6 2%
1e1 7 25.9 19.9 5%
1e1 8 31.3 38.3 -10%
1e1 9 25.2 28.3 0%
1e1 10 9.0 9.9 -11%
2e0 1 10.5 0.8 483%
2e0 2 4.3 4.2 -34%
2e0 3 69.3 40.7 21%
2e0 4 23.1 20.5 -21%
2e0 5 21.9 26.3 -7%
2e0 6 5.7 8.7 -41%
2e0 7 34.4 26.2 10%
2e0 8 33.3
2e0 9 18.5
2e0 10 9.3 9.3 -10%
NA fraction
by NA fraction Size (k=1e2, unsorted)
NA fraction Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 0.4 0.4 33%
0 1e8 3.1 3.4 -9%
0 1e9 78.1 66.1 15%
Sortedness
by Sortedness Size (k=1e2, no NA)
Sorted Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 0.4 0.4 33%
0 1e8 3.1 3.4 -9%
0 1e9 78.1 66.1 15%
1 1e7 0.3 0.3 -7%
1 1e8 2.9 3.2 -12%
1 1e9 22.4 24.9 -14%

join

join for clickhouse not yet implemented.

Details

Environment

Nodename: mr-dl11

Timings


Report was generated on: 2020-05-15 11:12:38 PDT.